# -*- coding: utf-8 -*-
import time
from selenium import webdriver
import unittest
import xlrd
from Page.loginPage import loginPage
from publicModule.login import login
from Page.scanningPage import scanningPage
from publicModule.scanning import scanning
from Page.insuredmtPage import insuredmtPage
from publicModule.insuredmt import insuredmt
class Test_Scanning(unittest.TestCase):
    @classmethod
    def setUpClass(self):
        print('开始测试')
        self.driver = webdriver.Chrome()
        self.driver.implicitly_wait(10)
        self.driver.maximize_window()
        self.driver.get("http://10.22.26.34:8080/fwd/indexlis.jsp")
        time.sleep(2)

        self.loginPage = loginPage(self.driver)
        self.login = login(self.driver)
        self.scanningPage=scanningPage(self.driver)
        self.scanning=scanning(self.driver)
        self.insuredmtPage = insuredmtPage(self.driver)
        self.insuredmt = insuredmt(self.driver)
    def test01(self):
        print('test01')
        filename='..//TestData//loginData.xlsx'
        excel_open=xlrd.open_workbook(filename)
        table=excel_open.sheet_by_name('Sheet1')
        rows=table.nrows
        for i in range(2,rows):
            row_content=table.row_values(i)
            username=row_content[0]
            password=row_content[1]
            orgcode=row_content[2]
            login.login(self,username,password,orgcode)
    def test02(self):
        scanning.grouplife(self)
        time.sleep(1)
        scanning.policymanage(self)
        time.sleep(1)
        scanning.scanning(self)
        time.sleep(1)
        filename = r'..\TestData\outputdata.xls'
        excel_open = xlrd.open_workbook(filename)
        table = excel_open.sheet_by_name('Sheet1')
        rows = table.nrows
        for i in range(1, rows):
            row_content = table.row_values(i)
            GrpPropNo = row_content[0]
            scanning.scaning1(self,GrpPropNo)
    def test03(self):
        filename =  '..//TestData//customerAdd.xlsx'
        excel_open = xlrd.open_workbook(filename)
        table = excel_open.sheet_by_name('Sheet1')
        rows = table.nrows
        for i in range(2, rows):
            row_content = table.row_values(i)
            insurancepolicytype = row_content[26]
            PolicyAppDate = row_content[27]
            scanning.Policyifm(self,insurancepolicytype,PolicyAppDate)







